Editing Student Test and Exam Scores

Editing / Modify Test and Exam Scores

Instruction:
Please Provide The Following Data and Click Display button
Please Click Edit Beside the Result you want to Edit and change test or Exam score from the form that appears
Student Regno
Academic Term
Academic Year

     
prepare( "SELECT * FROM marks where (stregno = '$reg' and term = '$term' ) and acad_session = '$yr'" ); $res->execute() ; $_SESSION["rgno"] = $reg ; $_SESSION["tm"] = $term; $_SESSION["yr"] = $yr ; //for($i=0; $row = mysql_fetch_array($ex); $i++){ while( $row =$res->FETCH(PDO::FETCH_ASSOC)) { $sbjid = $row['subject_id'] ; $sqlsbj =$DBcon->prepare( "select subject_id, subjectname from subjects where subject_id = '$sbjid'") ; $sqlsbj->execute() ; $rowsub = $sqlsbj->FETCH(PDO::FETCH_ASSOC) ; $mysubj = $rowsub['subjectname'] ; //$sa = 'Edit'; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; ?> " ; } //} } if (isset($_GET['rgn'])) { $a = $_GET['rgn'] ; $b = $_GET['term'] ; $c = $_GET['yr'] ; $res = $DBcon->prepare( "SELECT * FROM marks where (stregno = '$a' and term = '$b' ) and acad_session = '$c'"); $res->execute(); //for($i=0; $row = mysql_fetch_array($ex); $i++){ while( $row = $res->FETCH(PDO::FETCH_ASSOC)) { $sbjid = $row['subject_id'] ; $sqlsbj = $DBcon->prepare("select subject_id, subjectname from subjects where subject_id = '$sbjid'"); $sqlsbj->execute() ; $rowsub = $sqlsbj->FETCH(PDO::FETCH_ASSOC) ; $mysubj = $rowsub['subjectname'] ; //$sa = 'Edit'; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; ?> " ; } //} } ?>
Reg No Subject Name Test Score Project Score Exam Score Action
" . $row['stregno'] . "" . $mysubj . "" . $row['test'] . "" . $row['midterm'] . "" . $row['exam'] . "'>Edit |Delete
" . $row['stregno'] . "" . $mysubj . "" . $row['test'] . "" . $row['midterm'] . "" . $row['exam'] . "'>Edit |Delete

Simple and Easy, You can do it

For More Help ? Contact UsClick Here.